SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweConcursos
AS
SELECT idConcurso AS Id, Descripcion, Convocatoria, Fecha, Coordinacion, Localidad, Nivel, Modalidad, Estado
FROM  dbo.tb_Concursos
GO
GRANT SELECT ON  [dbo].[vweConcursos] TO [CentroDeDesignaciones]
GRANT INSERT ON  [dbo].[vweConcursos] TO [CentroDeDesignaciones]
GRANT DELETE ON  [dbo].[vweConcursos] TO [CentroDeDesignaciones]
GRANT UPDATE ON  [dbo].[vweConcursos] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweConcursos] TO [Juntas]
GRANT INSERT ON  [dbo].[vweConcursos] TO [Juntas]
GRANT DELETE ON  [dbo].[vweConcursos] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweConcursos] TO [Juntas]
GRANT SELECT ON  [dbo].[vweConcursos] TO [SoloVer]
GO
